CREATE EXTERNAL TABLE `spmi_ods`.`spmn_transfer_operation_network_relation`(`id` bigint COMMENT '主键ID', `fee_id` bigint COMMENT '中转费ID', `operation_network_id` bigint COMMENT '操作网点ID', `operation_network_code` string COMMENT '操作网点编码', `operation_network_name` string COMMENT '操作网点名称')
COMMENT ''
PARTITIONED BY (`dt` string COMMENT '更新/创建日期 (yyyy-MM-dd)')
ROW FORMAT SERDE 'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'
WITH SERDEPROPERTIES (
  'serialization.format' = '1'
)
STORED AS
  INPUTFORMAT 'org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat'
  OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat'
LOCATION 'hdfs://yl-bg-hdp/dw/hive/spmi_ods.db/external/spmn_transfer_operation_network_relation';